Covid 19 Analysis

By: Suraj Honkamble.

Import required libraries

Load and read the dataset

Column information

In the Boolean features, 1 means "yes" and 2 means "no" and values as 97 and 99 are missing data.

Data Cleaning

Unique values in all categorical column

In the Binary categorical features like Pneumonia, Diabetis etc we can see three or four unique values. As mentioned in dataset that values 97,98, 99 are corresponds to missing values. Lets replace 97,98, 99 with np.nan.

Above Columns contains 97,98 and 99 values lets replcae them

Now check the missing values

CLASIFFICATION_FINAL - Covid test results. covid test findings. Values 1-3 mean that the patient was diagnosed with covid in different degrees. 4 or higher means that the patient is not a carrier of covid or that the test is inconclusive.

We can replcae these values with 1 and 2, Values from 1 to 3 as 1(Positive) and 4 to 7 as 2(Negative)

Duplicate rows

We are just going to analyse the data so I am not going to drop any duplicates.

In the DIED_DATE column there is one entry "9999-99-99" which indicates person not died. Using this column create a new column "Died", if the DIED_DATE is "9999-99-99" then return 2(Not Died) or else return 1(Died).

Replace "9999-99-99" this died date with 0 so that we can analyze it properly.

Change data type to datetime

Data Analysis

Distribution of Age

Count of Categorical column

Correlation Matrix

Convert all the Descrete categorical columns into object

Rename the values are colmns so that it is easy to understand for everyone.

Age vs Covid Results(Classification FInal)

Any Age people are getting infected.

After taking primary level treatment how many patients died and survived?

43k People died after taking the primary treatment and 33k People died with no primary treatment.

In which level of medical Institution more patience are died?

More Patients died in Medical Unit=4 then in Medical Unit=12

Who's chances are more getting inffected, Male or Female?

Count of Patients died by Gender

Cout of patients who got inffected and died

Male and Female both are getting Inffected with same rate.

Male Deaths are more than the Female.

What type of patients are died?

Most of the Hospitalized people died.

How many Patients are died after keeping them on Ventilator?

Many Patients died without availability of Ventilators. And when the patient went on Ventilators the chances of death is high.

How Many Pneumonia Patients got inffected by Corona Virus?

How many Pneumonia Patients Died Due to Corona Virus?

Cout of Inffected and died Pneumonia patient

About 70% Corona Inffected Pneumonia Patients died.

How many Pregnent WOmes got inffected?

How Many Pregnent Inffected women died?

Very less paregnent women got inffected and the count of death is also very low.

How many Diabetic patients got inffected?

Count of dibetic patients died due to covid

Count of Diabetic inffected and died Patient

About 40% Diabetic Patients died after getting inffected by Corona VIrus.

How many COP Disease people got inffected?

Count of COP disease people died due to Corona

Count of COP Disease patient inffected and died

Death rate for COP disease people after getting covid inffection is very high.almost 70% Patients died.

How Many Asthma patient got inffected?

Count of Asthama people died due to corona

Count of Inffected and died Asthma patients

10% Asthma Patient died after covid inffection.

How many people with low Immune Systemgot inffected?

Count of people with weak Immune system died due to covid

Count of Low immune system people getting inffected and died

55% Low immune system people died afted covid affection.

How many Hypertensed people got inffected

How many Hypertensed people died

Count of Hypertensed people died after corona inffection

About 40% Inffected Hypertension people died.

How many Heart disease people died after covid inffection

Count of patience with heart disease got inffection and died

50% Cardiovescular related dieases people died after covid inffection.

How many people with Obesity got covid inffected

How many Obese people died

About 20% People with Obesity died due to covid inffection.

How many people with Chronical Renel disease had covid inffection

How many people with Chronical Renel disease has died

75% Chronical diseases People died after corona virus inffection.

How many TOBACCO consumming people got corona inffection

How many TOBACCO consumming people died after inffection

Only 2% Tobacco consuming people died after corona virus inffection.

How Many died in ICU

About 99% Patients who admitted to ICU are died. Most number of Patients died outside the ICU.

Deaths by Moths

Summary/Conclusion:

  1. Any age People are getting inffected by the Corona Virus.
  2. More People died after taking the primary treatment as compared to the people who has not taken any primary treatment and More Patients died in Medical Unit=4 then in Medical Unit=12.
  3. Male and Female both are getting Inffected with same rate but the Male Deaths are more than the Female.
  4. Most of the Hospitalized people died.
  5. Many Patients died without availability of Ventilators. And when the patient went on Ventilators the chances of death is high.
  6. About 70% Corona Inffected Pneumonia Patients died.
  7. Less amount Pregnent womens got inffected and the death count is also very low.
  8. About 40% Diabetic Patients died after getting inffected by Corona VIrus.
  9. Death rate for COP disease people after getting covid inffection is very high, almost 70% Patients died.
  10. 10% Asthma Patient died after covid inffection.
  11. 55% Low immune system people died afted covid affection. Very less percentage of people with strong Immune System died after getting infected.
  12. About 40% Inffected Hypertension people died.
  13. 50% Cardiovescular related dieases people died after covid inffection.
  14. About 20% People with Obesity, died due to covid inffection.
  15. 75% Chronical diseases People died after corona virus inffection.
  16. Only 2% Tobacco consuming people died after corona virus inffection.
  17. About 99% Patients who admitted to ICU are died. Most number of Patients died outside the ICU.
  18. In May, June and July 2020 Covid on its peak hence more Deaths recorded in these 3 Months.